package org.sems.sems.Mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.sems.sems.entity.Dcwjk;

import java.util.List;

@Mapper
public interface DcwjkMapper {

    int insertDcwjk(Dcwjk dcwjk);
    @Select("SELECT * FROM dcwjk WHERE id = #{dcwjid}")
    Dcwjk getDcwjkById(int dcwjid);

    @Select("SELECT * FROM dcwjk WHERE FBZ=#{fbz} and FBZSFDM=#{fbzsfdm} ")
    List<Dcwjk> getDcwjkByFBZ(@Param("fbz") String fbz,@Param("fbzsfdm") int fbzsfdm);
}

